﻿CREATE TABLE [investment].[Portfolio] (
    [Code]                   NVARCHAR (8)    NOT NULL,
    [Name]                   NVARCHAR (128)  NOT NULL,
    [Description]            NVARCHAR (4000) DEFAULT ('') NOT NULL,
    [ClientCode]             NVARCHAR (8)    NOT NULL,
    [CreatedDate]            DATETIME        DEFAULT (getdate()) NOT NULL,
    [LastCorrectionDateTime] DATETIME        DEFAULT (getdate()) NOT NULL,
    [NextCorrectionDateTime] DATETIME        DEFAULT (getdate()) NOT NULL,
    PRIMARY KEY CLUSTERED ([Code] ASC),
    CONSTRAINT [FK_Portfolio_Client] FOREIGN KEY ([ClientCode]) REFERENCES [investment].[Client] ([Code])
);





